package com.hahaliu.hahaliu.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.hahaliu.hahaliu.pojo.entity.Video;
import com.hahaliu.hahaliu.pojo.vo.VideoInfoVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author Liubuzhu
* @description 针对表【video】的数据库操作Mapper
* @createDate 2024-05-18 14:50:03
* @Entity com.hahaliu.hahaliu.pojo.entity.Video
*/
@Mapper
public interface VideoMapper extends BaseMapper<Video> {
	List<VideoInfoVO> listWithUser();

	// 获取指定状态的视频id
	@Select("select v_id from video where status = ${status}")
	List<Integer> getVIds(Integer status);

	@Select("select * from video")
	List<Video> listAll();

}




